

/****** Object:  StoredProcedure [dbo].[SP_recUser_Update]    Script Date: 05/10/2014 08:29:25 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

-- =============================================
-- Author:		Beni Khaeroni (jhung.ben@gmail.com)
-- Create date: 09 Mei 2014 10:20 AM
-- Description:	
-- =============================================

CREATE PROCEDURE [dbo].[SP_recUser_Update]
(
	@UserID						[int],
	@UserCode						[varchar](50),
	@UserName						[varchar](100),
	@Email						[varchar](50),
	--@Password						[varchar](50),
	@IsActive						[bit],
	@CabangID						[int],
	@NIK						[varchar](50),
	@LokasiID						[int],
	--@CreatedBy						[varchar](50),
	--@CreatedDate						[datetime],
	@UpdatedBy						[varchar](50),
	@UpdatedDate						[datetime],
	@IsForgotPass						[bit]
)
AS UPDATE master.recUser
SET
		--UserID			=	@UserID,
		UserCode			=	@UserCode,
		UserName			=	@UserName,
		Email			=	@Email,
		--Password			=	@Password,
		IsActive			=	@IsActive,
		CabangID			=	@CabangID,
		NIK			=	@NIK,
		LokasiID			=	@LokasiID,
		--CreatedBy			=	@CreatedBy,
		--CreatedDate			=	@CreatedDate,
		UpdatedBy			=	@UpdatedBy,
		UpdatedDate			=	@UpdatedDate,
		IsForgotPass			=	@IsForgotPass
WHERE
(
	 [UserID]	 = @UserID
)
GO


